﻿SET QUOTED_IDENTIFIER ON
GO
SET ARITHABORT ON
GO
SET NUMERIC_ROUNDABORT OFF
GO
SET CONCAT_NULL_YIELDS_NULL ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
SET ANSI_WARNINGS ON
GO


ALTER PROCEDURE [dbo].[bhp_NemoUsers]
AS
BEGIN

	SELECT 
		3000000 + idx as UserId,
		imie + ' ' + nazwisko as Name
	FROM 
		T1
	WHERE
		del = 0
		AND (imie IS NOT NULL OR nazwisko IS NOT NULL)
	UNION SELECT
		3000000,
		'NO LOGGED'

END
